On this page: the syntax of the SQL query

The syntax of the SQL query

The SQL query depends on the SQL language supported by your data connection. You can use fields of previous sections in your query. Example: 

SELECT [OrderID], [CustomerID], [EmployeeID], [OrderDate], 
[RequiredDate], [ShippedDate] 
FROM [Orders] 
where customerID='{[Customers].[CustomerID]}'

To insert values of other sections, use this syntax: 

{[name of the section].[name of the field]}